Computer Question Bank
for Exam preparation

Q2. Ms Access: Which of the following types of joins displays records with the same value in the common field?

1. Inner join
2. Left outer join
3. Right outer join
4. Self join

Q3. Ms Access: You can move between fields in a form by using any of these keys except

1. Tab
2. Enter
3. Shift+tab
4. Page up

Q4. What is the minimum header size of an IP packet?

1. 16 bytes
2. 10 bytes
3. 20 bytes
4. 32 bytes

Q5. Ms Access: Which of the following statement is true

1. Reports can be used to retrieve data from tables and calculate
2. Queries can be printed in well formatted manner and presented as the information
3. Queries can include calculated fields that do not exist in table
4. Reports and forms are similar but forms are use to print but reports to display on screen only

Q6. Ms Excel:Which function is not available in the Consolidate dialog box?

1. Pmt
2. Average
3. Max
4. Sum

Q7. Ms Excel:How do you display current date and time in MS Excel?

1. date ()
2. Today ()
3. now ()
4. time ()

Q8. Ms Excel:What does the NOW() function return?

1. It returns the serial number of the current date and time
2. It returns the serial number of the current date
3. It returns the serial number of the current time
4. None of the above

Q9. Which of the following memory is most volatile?

1. SRAM
2. DRAM
3. CMOS RAM
4. EEPROM

Q10. Ms Excel:How do you tell one cell from another?

1. By numbers
2. By letters
3. By its address
4. by color